Welcome to the ongoing series of posts by Grant Fritchey as he takes his vast knowledge of SQL Server and applies it to learning PostgreSQL. And of course, as every great writer does…shares it with you so you can learn from his triumphs and mistakes.

Grant Fritchey in PostgreSQL

How User-Defined Types work in PostgreSQL: a complete guide

Learn PostgreSQL User-Defined Types (UDTs) with clear examples of DOMAIN, COMPOSITE, ENUM, and RANGE types, plus practical SQL code for…

27 March 2026 14 min read 2

Grant Fritchey in PostgreSQL

Learning PostgreSQL with Grant: Data Storage

Learn how PostgreSQL stores data on disk, including page architecture, TOAST storage, file structure, tablespaces, and I/O performance optimization strategies.…

23 February 2026 12 min read 11

Grant Fritchey in PostgreSQL

Multi-Version Concurrency Control (MVCC) in PostgreSQL: Learning PostgreSQL with Grant

It’s a tale as old as time. You want to read data. Your mate wants to write data. You’re stepping…

02 April 2025 15 min read 31

Grant Fritchey in PostgreSQL

PostgreSQL Backups to Support Point In Time Recovery: Learning PostgreSQL with Grant

The focus of your backup strategy should not be backups. Instead, you should be focused on restoring databases, because, after…

07 September 2024 12 min read 111

PostgreSQL

Grant Fritchey in PostgreSQL

Functions and Procedures: Learning PostgreSQL with Grant

One of the most useful constructs in SQL Server is the stored procedure. It gives you a way to do…

15 February 2024 9 min read

PostgreSQL

Grant Fritchey in PostgreSQL

Introducing VACUUM: Learning PostgreSQL With Grant

While there are many features within PostgreSQL that are really similar to those within SQL Server, there are some that…

21 August 2023 11 min read

PostgreSQL

Grant Fritchey in PostgreSQL

Querying PostgreSQL: Learning PostgreSQL with Grant

Writing queries to retrieve the data from a database is probably the single most common task when it comes to…

24 July 2023 9 min read

PostgreSQL

Grant Fritchey in PostgreSQL

Manipulating Data In PostgreSQL: Learning PostgreSQL with Grant

So far in the series I’ve shown how to create databases, tables, constraints, indexes and schema. Now, it’s time to…

12 June 2023 13 min read

PostgreSQL

Grant Fritchey in PostgreSQL

PostgreSQL Schema: Learning PostgreSQL with Grant

An important aspect of building and managing a database is organizing the objects within your database. You may have tables…

10 April 2023 9 min read

PostgreSQL

Grant Fritchey in PostgreSQL

PostgreSQL Constraints: Learning PostgreSQL with Grant

One of the most important aspects of data management is the ability to ensure that the data in your database…

02 February 2023 23 min read

PostgreSQL

Grant Fritchey in PostgreSQL

Index Types in PostgreSQL: Learning PostgreSQL with Grant

As with any other relational data management system (RDBMS), PostgreSQL uses indexes as a mechanism to improve data access. PostgreSQL…

09 January 2023 15 min read

PostgreSQL

Grant Fritchey in PostgreSQL

Data Types in PostgreSQL: Learning PostgreSQL with Grant

PostgreSQL has an unusually large number of data types. Grant Fritchey reviews each data type and discusses the good and…

01 March 2022 17 min read

PostgreSQL

Grant Fritchey in PostgreSQL

How to back up and restore in PostgreSQL: Learning PostgreSQL with Grant

You can perform PostgreSQL backups with the pg_dump command. In this article, Grant Fritchey explains how to back up and…

08 February 2022 12 min read

PostgreSQL

Grant Fritchey in PostgreSQL

Creating a Database and Tables in PostgreSQL: Learning PostgreSQL with Grant

The syntax for creating databases and tables in PostgreSQL is similar to other RDBMS. In this article, Grant Fritchey shows…

10 January 2022 7 min read

Featured

Grant Fritchey in Featured

Connecting to PostgreSQL: Learning PostgreSQL with Grant

Database professionals often work with more than one database platform. Grant Fritchey explains setting up and connecting to PostgreSQL database.…

23 November 2021 7 min read